TYPE=TRIGGERS
triggers='CREATE DEFINER=`root`@`localhost` TRIGGER trig_recharge_update\nAFTER UPDATE\nON `ldsj_member_recharge` FOR EACH ROW\nBEGIN\nIF OLD.state = 1 OR OLD.state = 9 THEN\n     IF OLD.flag = 0   THEN\n          if NEW.amount>0 AND NEW.isDelete = 0 AND NEW.flag = 1 THEN\n               -- 每次充值赠送\n			   call setRechargeBack(NEW.amount, NEW.uid, NEW.id, NEW.rechargeId);\n         end if;\n     END IF;\nEND IF;\nEND'
sql_modes=0
definers='root@localhost'
